package com.ruoyi.system.mapper.media;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * 广电用户仪表盘数据访问层
 * 
 * @author ruoyi
 */
@Mapper
@Repository
public interface MediaDashboardMapper
{
    /**
     * 获取仪表盘基础数据
     * @return 仪表盘数据
     */
    @Select("SELECT 1000 as totalCount, 800 as activeCount, 100.5 as avgConsume, 200 as retentionCount")
    Map<String, Object> getDashboardData();

    /**
     * 获取基础指标统计
     * @return 统计数据
     */
    @Select("SELECT 1000 as totalCount, 800 as activeCount, 100.5 as avgConsume, 200 as retentionCount")
    Map<String, Object> getBasicStatistics();

    /**
     * 获取业务品牌分布
     * @return 品牌分布数据
     */
    @Select("SELECT 'Brand1' as name, 500 as value")
    List<Map<String, Object>> getBrandDistribution();

    /**
     * 获取用户价值等级分布
     * @return 价值等级分布数据
     */
    @Select("SELECT 'High' as name, 300 as value")
    List<Map<String, Object>> getValueLevelDistribution();

    /**
     * 获取用户状态分布
     * @return 状态分布数据
     */
    @Select("SELECT 'Active' as name, 600 as value")
    List<Map<String, Object>> getStatusDistribution();

    /**
     * 获取用户增长趋势
     * @return 增长趋势数据
     */
    @Select("SELECT '2023-01' as date, 100 as count")
    List<Map<String, Object>> getUserGrowthTrend();

    /**
     * 获取用户区域分布
     * @return 区域分布数据
     */
    @Select("SELECT 'Region1' as name, 400 as value")
    List<Map<String, Object>> getRegionDistribution();
}